Overview
Brought to you by YData
Dataset statistics
| Number of variables | 26 |
|---|---|
| Number of observations | 1696234 |
| Missing cells | 10226144 |
| Missing cells (%) | 23.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.5 GiB |
| Average record size in memory | 920.9 B |
Variable types
| Numeric | 12 |
|---|---|
| DateTime | 3 |
| Text | 6 |
| Categorical | 5 |
Unnamed: 0 is highly overall correlated with player_id | High correlation |
competition_id is highly overall correlated with current_club_domestic_competition_id | High correlation |
current_club_domestic_competition_id is highly overall correlated with competition_id | High correlation |
current_club_id is highly overall correlated with player_club_id and 1 other fields | High correlation |
highest_market_value_in_eur is highly overall correlated with market_value_in_eur | High correlation |
last_season is highly overall correlated with market_value_in_eur | High correlation |
market_value_in_eur is highly overall correlated with highest_market_value_in_eur and 1 other fields | High correlation |
player_club_id is highly overall correlated with current_club_id and 1 other fields | High correlation |
player_current_club_id is highly overall correlated with current_club_id and 1 other fields | High correlation |
player_id is highly overall correlated with Unnamed: 0 | High correlation |
position is highly overall correlated with sub_position | High correlation |
sub_position is highly overall correlated with position | High correlation |
first_name has 639134 (37.7%) missing values | Missing |
last_name has 639134 (37.7%) missing values | Missing |
name has 639134 (37.7%) missing values | Missing |
last_season has 639134 (37.7%) missing values | Missing |
current_club_id has 639134 (37.7%) missing values | Missing |
country_of_citizenship has 639134 (37.7%) missing values | Missing |
date_of_birth has 639134 (37.7%) missing values | Missing |
sub_position has 639134 (37.7%) missing values | Missing |
position has 639134 (37.7%) missing values | Missing |
foot has 639134 (37.7%) missing values | Missing |
height_in_cm has 639134 (37.7%) missing values | Missing |
contract_expiration_date has 639134 (37.7%) missing values | Missing |
current_club_domestic_competition_id has 639134 (37.7%) missing values | Missing |
current_club_name has 639134 (37.7%) missing values | Missing |
market_value_in_eur has 639134 (37.7%) missing values | Missing |
highest_market_value_in_eur has 639134 (37.7%) missing values | Missing |
Unnamed: 0 is uniformly distributed | Uniform |
Unnamed: 0 has unique values | Unique |
goals has 1550716 (91.4%) zeros | Zeros |
assists has 1577530 (93.0%) zeros | Zeros |
Reproduction
| Analysis started | 2025-03-12 19:11:15.317045 |
|---|---|
| Analysis finished | 2025-03-12 19:12:28.640726 |
| Duration | 1 minute and 13.32 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
Unnamed: 0
Real number (ℝ)
High correlation  Uniform  Unique 
| Distinct | 1696234 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 848116.5 |
| Minimum | 0 |
|---|---|
| Maximum | 1696233 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 84811.65 |
| Q1 | 424058.25 |
| median | 848116.5 |
| Q3 | 1272174.8 |
| 95-th percentile | 1611421.3 |
| Maximum | 1696233 |
| Range | 1696233 |
| Interquartile range (IQR) | 848116.5 |
Descriptive statistics
| Standard deviation | 489660.72 |
|---|---|
| Coefficient of variation (CV) | 0.57735078 |
| Kurtosis | -1.2 |
| Mean | 848116.5 |
| Median Absolute Deviation (MAD) | 424058.5 |
| Skewness | -3.935866 × 10-15 |
| Sum | 1.438604 × 1012 |
| Variance | 2.3976762 × 1011 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 1130818 | 1 | < 0.1% |
| 1130828 | 1 | < 0.1% |
| 1130827 | 1 | < 0.1% |
| 1130826 | 1 | < 0.1% |
| 1130825 | 1 | < 0.1% |
| 1130824 | 1 | < 0.1% |
| 1130823 | 1 | < 0.1% |
| 1130822 | 1 | < 0.1% |
| 1130821 | 1 | < 0.1% |
| Other values (1696224) | 1696224 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 1696233 | 1 | |
| 1696232 | 1 | |
| 1696231 | 1 | |
| 1696230 | 1 | |
| 1696229 | 1 | |
| 1696228 | 1 | |
| 1696227 | 1 | |
| 1696226 | 1 | |
| 1696225 | 1 | |
| 1696224 | 1 |
player_id
Real number (ℝ)
High correlation 
| Distinct | 25661 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 208378.44 |
| Minimum | 10 |
|---|---|
| Maximum | 1380876 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 15452 |
| Q1 | 58252 |
| median | 148396 |
| Q3 | 300168 |
| 95-th percentile | 603149 |
| Maximum | 1380876 |
| Range | 1380866 |
| Interquartile range (IQR) | 241916 |
Descriptive statistics
| Standard deviation | 192896.91 |
|---|---|
| Coefficient of variation (CV) | 0.92570471 |
| Kurtosis | 2.1678484 |
| Mean | 208378.44 |
| Median Absolute Deviation (MAD) | 103452 |
| Skewness | 1.4389208 |
| Sum | 3.534586 × 1011 |
| Variance | 3.7209217 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 38253 | 605 | < 0.1% |
| 32467 | 578 | < 0.1% |
| 59561 | 563 | < 0.1% |
| 125781 | 563 | < 0.1% |
| 74229 | 560 | < 0.1% |
| 36139 | 558 | < 0.1% |
| 28396 | 558 | < 0.1% |
| 56416 | 551 | < 0.1% |
| 91845 | 549 | < 0.1% |
| 65278 | 545 | < 0.1% |
| Other values (25651) | 1690604 |
| Value | Count | Frequency (%) |
| 10 | 136 | |
| 26 | 152 | |
| 65 | 122 | |
| 77 | 4 | < 0.1% |
| 80 | 12 | < 0.1% |
| 109 | 41 | < 0.1% |
| 123 | 7 | < 0.1% |
| 132 | 77 | |
| 215 | 109 | |
| 258 | 19 | < 0.1% |
| Value | Count | Frequency (%) |
| 1380876 | 1 | < 0.1% |
| 1378362 | 1 | < 0.1% |
| 1358447 | 1 | < 0.1% |
| 1310513 | 3 | < 0.1% |
| 1309326 | 3 | < 0.1% |
| 1306851 | 8 | |
| 1302421 | 5 | |
| 1294052 | 11 | |
| 1294049 | 5 | |
| 1294048 | 2 | < 0.1% |
player_club_id
Real number (ℝ)
High correlation 
| Distinct | 1064 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3124.6329 |
| Minimum | 1 |
|---|---|
| Maximum | 116786 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 27 |
| Q1 | 289 |
| median | 826 |
| Q3 | 2441 |
| 95-th percentile | 16239 |
| Maximum | 116786 |
| Range | 116785 |
| Interquartile range (IQR) | 2152 |
Descriptive statistics
| Standard deviation | 8249.8953 |
|---|---|
| Coefficient of variation (CV) | 2.6402767 |
| Kurtosis | 37.534735 |
| Mean | 3124.6329 |
| Median Absolute Deviation (MAD) | 626 |
| Skewness | 5.5674082 |
| Sum | 5.3001085 × 109 |
| Variance | 68060772 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 418 | 10257 | 0.6% |
| 131 | 10166 | 0.6% |
| 368 | 9983 | 0.6% |
| 506 | 9644 | 0.6% |
| 985 | 9631 | 0.6% |
| 281 | 9571 | 0.6% |
| 631 | 9554 | 0.6% |
| 31 | 9443 | 0.6% |
| 371 | 9358 | 0.6% |
| 27 | 9324 | 0.5% |
| Other values (1054) | 1599303 |
| Value | Count | Frequency (%) |
| 1 | 3 | < 0.1% |
| 2 | 13 | < 0.1% |
| 3 | 4896 | |
| 4 | 1501 | 0.1% |
| 5 | 8964 | |
| 6 | 467 | < 0.1% |
| 9 | 4 | < 0.1% |
| 10 | 1087 | 0.1% |
| 11 | 9290 | |
| 12 | 9022 |
| Value | Count | Frequency (%) |
| 116786 | 2 | < 0.1% |
| 110302 | 361 | |
| 101634 | 1 | < 0.1% |
| 101362 | 3 | < 0.1% |
| 99200 | 2 | < 0.1% |
| 91328 | 3 | < 0.1% |
| 87883 | 1 | < 0.1% |
| 86209 | 285 | |
| 85465 | 327 | |
| 83678 | 445 |
player_current_club_id
Real number (ℝ)
High correlation 
| Distinct | 437 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3979.6011 |
| Minimum | 3 |
|---|---|
| Maximum | 110302 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 29 |
| Q1 | 331 |
| median | 903 |
| Q3 | 2696 |
| 95-th percentile | 19771 |
| Maximum | 110302 |
| Range | 110299 |
| Interquartile range (IQR) | 2365 |
Descriptive statistics
| Standard deviation | 10806.848 |
|---|---|
| Coefficient of variation (CV) | 2.7155607 |
| Kurtosis | 30.513812 |
| Mean | 3979.6011 |
| Median Absolute Deviation (MAD) | 713 |
| Skewness | 5.100011 |
| Sum | 6.7503347 × 109 |
| Variance | 1.1678797 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 36 | 11702 | 0.7% |
| 683 | 10785 | 0.6% |
| 1091 | 10266 | 0.6% |
| 150 | 10255 | 0.6% |
| 46 | 10109 | 0.6% |
| 141 | 10108 | 0.6% |
| 13 | 9981 | 0.6% |
| 2381 | 9958 | 0.6% |
| 368 | 9628 | 0.6% |
| 589 | 9498 | 0.6% |
| Other values (427) | 1593944 |
| Value | Count | Frequency (%) |
| 3 | 4765 | |
| 4 | 987 | 0.1% |
| 5 | 8638 | |
| 6 | 618 | < 0.1% |
| 10 | 1190 | 0.1% |
| 11 | 7593 | |
| 12 | 8008 | |
| 13 | 9981 | |
| 15 | 7461 | |
| 16 | 6481 |
| Value | Count | Frequency (%) |
| 110302 | 2320 | |
| 86209 | 729 | < 0.1% |
| 85465 | 1892 | 0.1% |
| 83678 | 769 | < 0.1% |
| 75231 | 824 | < 0.1% |
| 71985 | 1222 | 0.1% |
| 68608 | 1977 | |
| 63007 | 2555 | |
| 61825 | 2392 | |
| 60949 | 4824 |
date
Date
| Distinct | 3717 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.9 MiB |
| Minimum | 2012-07-03 00:00:00 |
|---|---|
| Maximum | 2025-03-10 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
player_name
Text
| Distinct | 25119 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 126.2 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 29 |
| Mean length | 13.473428 |
| Min length | 2 |
Unique
| Unique | 2111 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Aurélien Joachim |
|---|---|
| 2nd row | Ruslan Abyshov |
| 3rd row | Sander Puri |
| 4th row | Vegar Hedenstad |
| 5th row | Markus Henriksen |
| Value | Count | Frequency (%) |
| de | 14398 | 0.4% |
| van | 14237 | 0.4% |
| david | 11680 | 0.3% |
| lucas | 9957 | 0.3% |
| thomas | 8444 | 0.3% |
| kevin | 7908 | 0.2% |
| daniel | 7764 | 0.2% |
| andré | 7245 | 0.2% |
| pedro | 7121 | 0.2% |
| joão | 7084 | 0.2% |
| Other values (23832) | 3280994 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 2268340 | 9.9% |
| e | 1733616 | 7.6% |
| 1680598 | 7.4% | |
| i | 1628621 | 7.1% |
| o | 1530209 | 6.7% |
| n | 1496563 | 6.5% |
| r | 1419771 | 6.2% |
| l | 991297 | 4.3% |
| s | 990515 | 4.3% |
| t | 678702 | 3.0% |
| Other values (111) | 8435854 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 22854086 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 2268340 | 9.9% |
| e | 1733616 | 7.6% |
| 1680598 | 7.4% | |
| i | 1628621 | 7.1% |
| o | 1530209 | 6.7% |
| n | 1496563 | 6.5% |
| r | 1419771 | 6.2% |
| l | 991297 | 4.3% |
| s | 990515 | 4.3% |
| t | 678702 | 3.0% |
| Other values (111) | 8435854 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 22854086 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 2268340 | 9.9% |
| e | 1733616 | 7.6% |
| 1680598 | 7.4% | |
| i | 1628621 | 7.1% |
| o | 1530209 | 6.7% |
| n | 1496563 | 6.5% |
| r | 1419771 | 6.2% |
| l | 991297 | 4.3% |
| s | 990515 | 4.3% |
| t | 678702 | 3.0% |
| Other values (111) | 8435854 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 22854086 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 2268340 | 9.9% |
| e | 1733616 | 7.6% |
| 1680598 | 7.4% | |
| i | 1628621 | 7.1% |
| o | 1530209 | 6.7% |
| n | 1496563 | 6.5% |
| r | 1419771 | 6.2% |
| l | 991297 | 4.3% |
| s | 990515 | 4.3% |
| t | 678702 | 3.0% |
| Other values (111) | 8435854 |
competition_id
Categorical
High correlation 
| Distinct | 43 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 97.0 MiB |
| IT1 | |
|---|---|
| ES1 | |
| GB1 | |
| FR1 | |
| TR1 | |
| Other values (38) |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 2.9325748 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CLQ |
|---|---|
| 2nd row | ELQ |
| 3rd row | ELQ |
| 4th row | ELQ |
| 5th row | ELQ |
Common Values
| Value | Count | Frequency (%) |
| IT1 | 139849 | 8.2% |
| ES1 | 138147 | 8.1% |
| GB1 | 135091 | 8.0% |
| FR1 | 131229 | 7.7% |
| TR1 | 119614 | 7.1% |
| L1 | 112441 | 6.6% |
| NL1 | 107748 | 6.4% |
| PO1 | 107305 | 6.3% |
| BE1 | 92929 | 5.5% |
| RU1 | 85204 | 5.0% |
| Other values (33) | 526677 |
Length
| Value | Count | Frequency (%) |
| it1 | 139849 | 8.2% |
| es1 | 138147 | 8.1% |
| gb1 | 135091 | 8.0% |
| fr1 | 131229 | 7.7% |
| tr1 | 119614 | 7.1% |
| l1 | 112441 | 6.6% |
| nl1 | 107748 | 6.4% |
| po1 | 107305 | 6.3% |
| be1 | 92929 | 5.5% |
| ru1 | 85204 | 5.0% |
| Other values (33) | 526677 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 1451827 | |
| R | 532295 | 10.7% |
| L | 353586 | 7.1% |
| E | 302983 | 6.1% |
| T | 269688 | 5.4% |
| B | 241271 | 4.9% |
| G | 232914 | 4.7% |
| S | 222972 | 4.5% |
| C | 183736 | 3.7% |
| P | 176424 | 3.5% |
| Other values (10) | 1006637 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4974333 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 1451827 | |
| R | 532295 | 10.7% |
| L | 353586 | 7.1% |
| E | 302983 | 6.1% |
| T | 269688 | 5.4% |
| B | 241271 | 4.9% |
| G | 232914 | 4.7% |
| S | 222972 | 4.5% |
| C | 183736 | 3.7% |
| P | 176424 | 3.5% |
| Other values (10) | 1006637 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4974333 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 1451827 | |
| R | 532295 | 10.7% |
| L | 353586 | 7.1% |
| E | 302983 | 6.1% |
| T | 269688 | 5.4% |
| B | 241271 | 4.9% |
| G | 232914 | 4.7% |
| S | 222972 | 4.5% |
| C | 183736 | 3.7% |
| P | 176424 | 3.5% |
| Other values (10) | 1006637 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4974333 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 1451827 | |
| R | 532295 | 10.7% |
| L | 353586 | 7.1% |
| E | 302983 | 6.1% |
| T | 269688 | 5.4% |
| B | 241271 | 4.9% |
| G | 232914 | 4.7% |
| S | 222972 | 4.5% |
| C | 183736 | 3.7% |
| P | 176424 | 3.5% |
| Other values (10) | 1006637 |
goals
Real number (ℝ)
Zeros 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.095945489 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 1550716 |
| Zeros (%) | 91.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.33104299 |
|---|---|
| Coefficient of variation (CV) | 3.4503236 |
| Kurtosis | 17.871832 |
| Mean | 0.095945489 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.8743377 |
| Sum | 162746 |
| Variance | 0.10958946 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1550716 | |
| 1 | 130219 | 7.7% |
| 2 | 13566 | 0.8% |
| 3 | 1562 | 0.1% |
| 4 | 147 | < 0.1% |
| 5 | 23 | < 0.1% |
| 6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 1550716 | |
| 1 | 130219 | 7.7% |
| 2 | 13566 | 0.8% |
| 3 | 1562 | 0.1% |
| 4 | 147 | < 0.1% |
| 5 | 23 | < 0.1% |
| 6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 6 | 1 | < 0.1% |
| 5 | 23 | < 0.1% |
| 4 | 147 | < 0.1% |
| 3 | 1562 | 0.1% |
| 2 | 13566 | 0.8% |
| 1 | 130219 | 7.7% |
| 0 | 1550716 |
assists
Real number (ℝ)
Zeros 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.075450085 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 1577530 |
| Zeros (%) | 93.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.28542405 |
|---|---|
| Coefficient of variation (CV) | 3.782952 |
| Kurtosis | 18.381554 |
| Mean | 0.075450085 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.0511294 |
| Sum | 127981 |
| Variance | 0.081466887 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1577530 | |
| 1 | 110036 | 6.5% |
| 2 | 8100 | 0.5% |
| 3 | 530 | < 0.1% |
| 4 | 36 | < 0.1% |
| 5 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 1577530 | |
| 1 | 110036 | 6.5% |
| 2 | 8100 | 0.5% |
| 3 | 530 | < 0.1% |
| 4 | 36 | < 0.1% |
| 5 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 6 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 4 | 36 | < 0.1% |
| 3 | 530 | < 0.1% |
| 2 | 8100 | 0.5% |
| 1 | 110036 | 6.5% |
| 0 | 1577530 |
minutes_played
Real number (ℝ)
| Distinct | 122 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 69.089002 |
| Minimum | 1 |
|---|---|
| Maximum | 148 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 45 |
| median | 90 |
| Q3 | 90 |
| 95-th percentile | 90 |
| Maximum | 148 |
| Range | 147 |
| Interquartile range (IQR) | 45 |
Descriptive statistics
| Standard deviation | 29.981585 |
|---|---|
| Coefficient of variation (CV) | 0.43395597 |
| Kurtosis | -0.38137871 |
| Mean | 69.089002 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.0701778 |
| Sum | 1.1719112 × 108 |
| Variance | 898.89546 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 90 | 907176 | |
| 45 | 66235 | 3.9% |
| 1 | 26371 | 1.6% |
| 78 | 11748 | 0.7% |
| 12 | 11618 | 0.7% |
| 76 | 11593 | 0.7% |
| 77 | 11549 | 0.7% |
| 14 | 11507 | 0.7% |
| 75 | 11498 | 0.7% |
| 74 | 11495 | 0.7% |
| Other values (112) | 615444 |
| Value | Count | Frequency (%) |
| 1 | 26371 | |
| 2 | 7796 | 0.5% |
| 3 | 8545 | 0.5% |
| 4 | 9092 | 0.5% |
| 5 | 9663 | 0.6% |
| 6 | 10271 | 0.6% |
| 7 | 10756 | |
| 8 | 11084 | |
| 9 | 11253 | |
| 10 | 11241 |
| Value | Count | Frequency (%) |
| 148 | 1 | < 0.1% |
| 135 | 2 | < 0.1% |
| 120 | 8142 | |
| 119 | 30 | < 0.1% |
| 118 | 30 | < 0.1% |
| 117 | 25 | < 0.1% |
| 116 | 21 | < 0.1% |
| 115 | 43 | < 0.1% |
| 114 | 28 | < 0.1% |
| 113 | 41 | < 0.1% |
first_name
Text
Missing 
| Distinct | 4327 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 639134 |
| Missing (%) | 37.7% |
| Memory size | 86.0 MiB |
Length
| Max length | 19 |
|---|---|
| Median length | 17 |
| Mean length | 5.8893984 |
| Min length | 2 |
Unique
| Unique | 157 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Sander |
|---|---|
| 2nd row | Vegar |
| 3rd row | Markus |
| 4th row | Peter |
| 5th row | Dušan |
| Value | Count | Frequency (%) |
| david | 6935 | 0.6% |
| lucas | 6198 | 0.6% |
| kevin | 5981 | 0.6% |
| thomas | 5256 | 0.5% |
| marco | 4859 | 0.5% |
| daniel | 4815 | 0.5% |
| jordan | 4376 | 0.4% |
| josé | 4280 | 0.4% |
| ivan | 4178 | 0.4% |
| aleksandr | 4175 | 0.4% |
| Other values (4250) | 1017562 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 678099 | 10.9% |
| i | 513525 | 8.2% |
| n | 474548 | 7.6% |
| e | 467321 | 7.5% |
| o | 431505 | 6.9% |
| r | 424406 | 6.8% |
| l | 295512 | 4.7% |
| s | 284348 | 4.6% |
| t | 193573 | 3.1% |
| d | 168892 | 2.7% |
| Other values (88) | 2293954 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6225683 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 678099 | 10.9% |
| i | 513525 | 8.2% |
| n | 474548 | 7.6% |
| e | 467321 | 7.5% |
| o | 431505 | 6.9% |
| r | 424406 | 6.8% |
| l | 295512 | 4.7% |
| s | 284348 | 4.6% |
| t | 193573 | 3.1% |
| d | 168892 | 2.7% |
| Other values (88) | 2293954 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6225683 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 678099 | 10.9% |
| i | 513525 | 8.2% |
| n | 474548 | 7.6% |
| e | 467321 | 7.5% |
| o | 431505 | 6.9% |
| r | 424406 | 6.8% |
| l | 295512 | 4.7% |
| s | 284348 | 4.6% |
| t | 193573 | 3.1% |
| d | 168892 | 2.7% |
| Other values (88) | 2293954 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6225683 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 678099 | 10.9% |
| i | 513525 | 8.2% |
| n | 474548 | 7.6% |
| e | 467321 | 7.5% |
| o | 431505 | 6.9% |
| r | 424406 | 6.8% |
| l | 295512 | 4.7% |
| s | 284348 | 4.6% |
| t | 193573 | 3.1% |
| d | 168892 | 2.7% |
| Other values (88) | 2293954 |
last_name
Text
Missing 
| Distinct | 11003 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 639134 |
| Missing (%) | 37.7% |
| Memory size | 88.3 MiB |
Length
| Max length | 22 |
|---|---|
| Median length | 19 |
| Mean length | 6.9684278 |
| Min length | 2 |
Unique
| Unique | 624 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Puri |
|---|---|
| 2nd row | Hedenstad |
| 3rd row | Henriksen |
| 4th row | Ankersen |
| 5th row | Tadić |
| Value | Count | Frequency (%) |
| de | 10214 | 0.9% |
| van | 9376 | 0.9% |
| silva | 3655 | 0.3% |
| garcía | 3177 | 0.3% |
| el | 3144 | 0.3% |
| martínez | 2632 | 0.2% |
| fernandes | 2440 | 0.2% |
| sánchez | 2342 | 0.2% |
| costa | 2310 | 0.2% |
| rodríguez | 2242 | 0.2% |
| Other values (10996) | 1053509 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 798714 | 10.8% |
| e | 636956 | 8.6% |
| i | 520750 | 7.1% |
| o | 510787 | 6.9% |
| r | 480763 | 6.5% |
| n | 475599 | 6.5% |
| s | 355810 | 4.8% |
| l | 341257 | 4.6% |
| t | 238013 | 3.2% |
| u | 234199 | 3.2% |
| Other values (95) | 2773477 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7366325 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 798714 | 10.8% |
| e | 636956 | 8.6% |
| i | 520750 | 7.1% |
| o | 510787 | 6.9% |
| r | 480763 | 6.5% |
| n | 475599 | 6.5% |
| s | 355810 | 4.8% |
| l | 341257 | 4.6% |
| t | 238013 | 3.2% |
| u | 234199 | 3.2% |
| Other values (95) | 2773477 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7366325 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 798714 | 10.8% |
| e | 636956 | 8.6% |
| i | 520750 | 7.1% |
| o | 510787 | 6.9% |
| r | 480763 | 6.5% |
| n | 475599 | 6.5% |
| s | 355810 | 4.8% |
| l | 341257 | 4.6% |
| t | 238013 | 3.2% |
| u | 234199 | 3.2% |
| Other values (95) | 2773477 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7366325 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 798714 | 10.8% |
| e | 636956 | 8.6% |
| i | 520750 | 7.1% |
| o | 510787 | 6.9% |
| r | 480763 | 6.5% |
| n | 475599 | 6.5% |
| s | 355810 | 4.8% |
| l | 341257 | 4.6% |
| t | 238013 | 3.2% |
| u | 234199 | 3.2% |
| Other values (95) | 2773477 |
name
Text
Missing 
| Distinct | 13737 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 639134 |
| Missing (%) | 37.7% |
| Memory size | 99.0 MiB |
Length
| Max length | 31 |
|---|---|
| Median length | 27 |
| Mean length | 13.857826 |
| Min length | 6 |
Unique
| Unique | 882 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Sander Puri |
|---|---|
| 2nd row | Vegar Hedenstad |
| 3rd row | Markus Henriksen |
| 4th row | Peter Ankersen |
| 5th row | Dušan Tadić |
| Value | Count | Frequency (%) |
| de | 10214 | 0.5% |
| van | 9376 | 0.4% |
| david | 7246 | 0.3% |
| lucas | 6251 | 0.3% |
| thomas | 6055 | 0.3% |
| kevin | 5981 | 0.3% |
| marco | 4860 | 0.2% |
| andré | 4860 | 0.2% |
| daniel | 4815 | 0.2% |
| jordan | 4376 | 0.2% |
| Other values (14868) | 2099622 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 1476813 | 10.1% |
| 1106556 | 7.6% | |
| e | 1104277 | 7.5% |
| i | 1034275 | 7.1% |
| n | 950147 | 6.5% |
| o | 942292 | 6.4% |
| r | 905169 | 6.2% |
| s | 640158 | 4.4% |
| l | 636769 | 4.3% |
| t | 431586 | 2.9% |
| Other values (102) | 5421066 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 14649108 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 1476813 | 10.1% |
| 1106556 | 7.6% | |
| e | 1104277 | 7.5% |
| i | 1034275 | 7.1% |
| n | 950147 | 6.5% |
| o | 942292 | 6.4% |
| r | 905169 | 6.2% |
| s | 640158 | 4.4% |
| l | 636769 | 4.3% |
| t | 431586 | 2.9% |
| Other values (102) | 5421066 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 14649108 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 1476813 | 10.1% |
| 1106556 | 7.6% | |
| e | 1104277 | 7.5% |
| i | 1034275 | 7.1% |
| n | 950147 | 6.5% |
| o | 942292 | 6.4% |
| r | 905169 | 6.2% |
| s | 640158 | 4.4% |
| l | 636769 | 4.3% |
| t | 431586 | 2.9% |
| Other values (102) | 5421066 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 14649108 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 1476813 | 10.1% |
| 1106556 | 7.6% | |
| e | 1104277 | 7.5% |
| i | 1034275 | 7.1% |
| n | 950147 | 6.5% |
| o | 942292 | 6.4% |
| r | 905169 | 6.2% |
| s | 640158 | 4.4% |
| l | 636769 | 4.3% |
| t | 431586 | 2.9% |
| Other values (102) | 5421066 |
last_season
Real number (ℝ)
High correlation  Missing 
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 639134 |
| Missing (%) | 37.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2022.5416 |
| Minimum | 2012 |
|---|---|
| Maximum | 2024 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 2012 |
|---|---|
| 5-th percentile | 2017 |
| Q1 | 2022 |
| median | 2024 |
| Q3 | 2024 |
| 95-th percentile | 2024 |
| Maximum | 2024 |
| Range | 12 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2.3321668 |
|---|---|
| Coefficient of variation (CV) | 0.0011530872 |
| Kurtosis | 3.0969526 |
| Mean | 2022.5416 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.8648831 |
| Sum | 2.1380287 × 109 |
| Variance | 5.4390021 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2024 | 602267 | |
| 2023 | 136924 | 8.1% |
| 2021 | 74743 | 4.4% |
| 2022 | 67704 | 4.0% |
| 2020 | 55313 | 3.3% |
| 2019 | 34412 | 2.0% |
| 2018 | 28504 | 1.7% |
| 2017 | 19381 | 1.1% |
| 2016 | 14696 | 0.9% |
| 2015 | 10815 | 0.6% |
| Other values (3) | 12341 | 0.7% |
| (Missing) | 639134 |
| Value | Count | Frequency (%) |
| 2012 | 1489 | 0.1% |
| 2013 | 3820 | 0.2% |
| 2014 | 7032 | 0.4% |
| 2015 | 10815 | 0.6% |
| 2016 | 14696 | 0.9% |
| 2017 | 19381 | 1.1% |
| 2018 | 28504 | 1.7% |
| 2019 | 34412 | |
| 2020 | 55313 | |
| 2021 | 74743 |
| Value | Count | Frequency (%) |
| 2024 | 602267 | |
| 2023 | 136924 | 8.1% |
| 2022 | 67704 | 4.0% |
| 2021 | 74743 | 4.4% |
| 2020 | 55313 | 3.3% |
| 2019 | 34412 | 2.0% |
| 2018 | 28504 | 1.7% |
| 2017 | 19381 | 1.1% |
| 2016 | 14696 | 0.9% |
| 2015 | 10815 | 0.6% |
current_club_id
Real number (ℝ)
High correlation  Missing 
| Distinct | 436 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 639134 |
| Missing (%) | 37.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3957.3817 |
| Minimum | 3 |
|---|---|
| Maximum | 110302 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 27 |
| Q1 | 281 |
| median | 800 |
| Q3 | 2503 |
| 95-th percentile | 18303 |
| Maximum | 110302 |
| Range | 110299 |
| Interquartile range (IQR) | 2222 |
Descriptive statistics
| Standard deviation | 11236.602 |
|---|---|
| Coefficient of variation (CV) | 2.8394031 |
| Kurtosis | 30.242986 |
| Mean | 3957.3817 |
| Median Absolute Deviation (MAD) | 620 |
| Skewness | 5.1230434 |
| Sum | 4.1833482 × 109 |
| Variance | 1.2626122 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 46 | 7890 | 0.5% |
| 36 | 7821 | 0.5% |
| 141 | 7764 | 0.5% |
| 13 | 7410 | 0.4% |
| 27 | 7106 | 0.4% |
| 244 | 6984 | 0.4% |
| 2441 | 6948 | 0.4% |
| 800 | 6749 | 0.4% |
| 1091 | 6735 | 0.4% |
| 418 | 6664 | 0.4% |
| Other values (426) | 985029 | |
| (Missing) | 639134 |
| Value | Count | Frequency (%) |
| 3 | 3396 | |
| 4 | 588 | < 0.1% |
| 5 | 5758 | |
| 6 | 207 | < 0.1% |
| 10 | 869 | 0.1% |
| 11 | 5284 | |
| 12 | 6120 | |
| 13 | 7410 | |
| 15 | 5583 | |
| 16 | 5542 |
| Value | Count | Frequency (%) |
| 110302 | 1651 | |
| 86209 | 703 | < 0.1% |
| 85465 | 1860 | |
| 83678 | 547 | < 0.1% |
| 75231 | 819 | < 0.1% |
| 71985 | 1154 | 0.1% |
| 68608 | 282 | < 0.1% |
| 63007 | 2080 | |
| 61825 | 1200 | 0.1% |
| 60949 | 3456 |
Missing 
| Distinct | 160 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 639134 |
| Missing (%) | 37.7% |
| Memory size | 85.2 MiB |
Length
| Max length | 24 |
|---|---|
| Median length | 21 |
| Mean length | 7.2155737 |
| Min length | 4 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Estonia |
|---|---|
| 2nd row | Norway |
| 3rd row | Norway |
| 4th row | Denmark |
| 5th row | Serbia |
| Value | Count | Frequency (%) |
| spain | 87042 | 7.9% |
| france | 68495 | 6.2% |
| netherlands | 57445 | 5.2% |
| england | 50233 | 4.5% |
| germany | 48818 | 4.4% |
| italy | 46588 | 4.2% |
| portugal | 41153 | 3.7% |
| russia | 40992 | 3.7% |
| ukraine | 39810 | 3.6% |
| belgium | 38615 | 3.5% |
| Other values (177) | 588458 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 967578 | 12.7% |
| e | 771955 | 10.1% |
| n | 710105 | 9.3% |
| r | 610939 | 8.0% |
| i | 494101 | 6.5% |
| l | 394209 | 5.2% |
| o | 296412 | 3.9% |
| t | 289315 | 3.8% |
| g | 233037 | 3.1% |
| u | 224036 | 2.9% |
| Other values (46) | 2635896 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7627583 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 967578 | 12.7% |
| e | 771955 | 10.1% |
| n | 710105 | 9.3% |
| r | 610939 | 8.0% |
| i | 494101 | 6.5% |
| l | 394209 | 5.2% |
| o | 296412 | 3.9% |
| t | 289315 | 3.8% |
| g | 233037 | 3.1% |
| u | 224036 | 2.9% |
| Other values (46) | 2635896 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7627583 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 967578 | 12.7% |
| e | 771955 | 10.1% |
| n | 710105 | 9.3% |
| r | 610939 | 8.0% |
| i | 494101 | 6.5% |
| l | 394209 | 5.2% |
| o | 296412 | 3.9% |
| t | 289315 | 3.8% |
| g | 233037 | 3.1% |
| u | 224036 | 2.9% |
| Other values (46) | 2635896 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7627583 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 967578 | 12.7% |
| e | 771955 | 10.1% |
| n | 710105 | 9.3% |
| r | 610939 | 8.0% |
| i | 494101 | 6.5% |
| l | 394209 | 5.2% |
| o | 296412 | 3.9% |
| t | 289315 | 3.8% |
| g | 233037 | 3.1% |
| u | 224036 | 2.9% |
| Other values (46) | 2635896 |
date_of_birth
Date
Missing 
| Distinct | 6024 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 639134 |
| Missing (%) | 37.7% |
| Memory size | 12.9 MiB |
| Minimum | 1978-01-28 00:00:00 |
|---|---|
| Maximum | 2008-09-21 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
sub_position
Categorical
High correlation  Missing 
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 639134 |
| Missing (%) | 37.7% |
| Memory size | 109.6 MiB |
| Centre-Back | |
|---|---|
| Centre-Forward | |
| Central Midfield | |
| Defensive Midfield | |
| Right-Back | |
| Other values (8) |
Length
| Max length | 18 |
|---|---|
| Median length | 14 |
| Mean length | 13.046192 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Central Midfield |
|---|---|
| 2nd row | Right-Back |
| 3rd row | Centre-Back |
| 4th row | Right-Back |
| 5th row | Right Winger |
Common Values
| Value | Count | Frequency (%) |
| Centre-Back | 190516 | 11.2% |
| Centre-Forward | 149256 | 8.8% |
| Central Midfield | 139159 | 8.2% |
| Defensive Midfield | 93685 | 5.5% |
| Right-Back | 88969 | 5.2% |
| Attacking Midfield | 76323 | 4.5% |
| Right Winger | 76199 | 4.5% |
| Goalkeeper | 75434 | 4.4% |
| Left Winger | 72740 | 4.3% |
| Left-Back | 71798 | 4.2% |
| Other values (3) | 23021 | 1.4% |
| (Missing) | 639134 |
Length
| Value | Count | Frequency (%) |
| midfield | 324232 | |
| centre-back | 190516 | |
| centre-forward | 149256 | |
| winger | 148939 | |
| central | 139159 | |
| defensive | 93685 | 6.1% |
| right-back | 88969 | 5.8% |
| right | 83412 | 5.4% |
| left | 80592 | 5.2% |
| attacking | 76323 | 5.0% |
| Other values (4) | 163144 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1967533 | |
| i | 1147748 | 8.3% |
| r | 1017728 | 7.4% |
| t | 964304 | 7.0% |
| n | 805834 | 5.8% |
| d | 805676 | 5.8% |
| a | 791455 | 5.7% |
| f | 570307 | 4.1% |
| l | 538825 | 3.9% |
| k | 510996 | 3.7% |
| Other values (21) | 4670724 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 13791130 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 1967533 | |
| i | 1147748 | 8.3% |
| r | 1017728 | 7.4% |
| t | 964304 | 7.0% |
| n | 805834 | 5.8% |
| d | 805676 | 5.8% |
| a | 791455 | 5.7% |
| f | 570307 | 4.1% |
| l | 538825 | 3.9% |
| k | 510996 | 3.7% |
| Other values (21) | 4670724 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 13791130 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 1967533 | |
| i | 1147748 | 8.3% |
| r | 1017728 | 7.4% |
| t | 964304 | 7.0% |
| n | 805834 | 5.8% |
| d | 805676 | 5.8% |
| a | 791455 | 5.7% |
| f | 570307 | 4.1% |
| l | 538825 | 3.9% |
| k | 510996 | 3.7% |
| Other values (21) | 4670724 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 13791130 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 1967533 | |
| i | 1147748 | 8.3% |
| r | 1017728 | 7.4% |
| t | 964304 | 7.0% |
| n | 805834 | 5.8% |
| d | 805676 | 5.8% |
| a | 791455 | 5.7% |
| f | 570307 | 4.1% |
| l | 538825 | 3.9% |
| k | 510996 | 3.7% |
| Other values (21) | 4670724 |
position
Categorical
High correlation  Missing 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 639134 |
| Missing (%) | 37.7% |
| Memory size | 104.1 MiB |
| Defender | |
|---|---|
| Midfield | |
| Attack | |
| Goalkeeper |
Length
| Max length | 10 |
|---|---|
| Median length | 8 |
| Mean length | 7.5634907 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Midfield |
|---|---|
| 2nd row | Defender |
| 3rd row | Defender |
| 4th row | Defender |
| 5th row | Attack |
Common Values
| Value | Count | Frequency (%) |
| Defender | 351283 | |
| Midfield | 324232 | |
| Attack | 306151 | |
| Goalkeeper | 75434 | 4.4% |
| (Missing) | 639134 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| defender | 351283 | |
| midfield | 324232 | |
| attack | 306151 | |
| goalkeeper | 75434 | 7.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1604383 | |
| d | 999747 | |
| f | 675515 | |
| i | 648464 | |
| t | 612302 | 7.7% |
| r | 426717 | 5.3% |
| l | 399666 | 5.0% |
| k | 381585 | 4.8% |
| a | 381585 | 4.8% |
| D | 351283 | 4.4% |
| Other values (7) | 1514119 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7995366 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 1604383 | |
| d | 999747 | |
| f | 675515 | |
| i | 648464 | |
| t | 612302 | 7.7% |
| r | 426717 | 5.3% |
| l | 399666 | 5.0% |
| k | 381585 | 4.8% |
| a | 381585 | 4.8% |
| D | 351283 | 4.4% |
| Other values (7) | 1514119 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7995366 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 1604383 | |
| d | 999747 | |
| f | 675515 | |
| i | 648464 | |
| t | 612302 | 7.7% |
| r | 426717 | 5.3% |
| l | 399666 | 5.0% |
| k | 381585 | 4.8% |
| a | 381585 | 4.8% |
| D | 351283 | 4.4% |
| Other values (7) | 1514119 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7995366 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 1604383 | |
| d | 999747 | |
| f | 675515 | |
| i | 648464 | |
| t | 612302 | 7.7% |
| r | 426717 | 5.3% |
| l | 399666 | 5.0% |
| k | 381585 | 4.8% |
| a | 381585 | 4.8% |
| D | 351283 | 4.4% |
| Other values (7) | 1514119 |
foot
Categorical
Missing 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 639134 |
| Missing (%) | 37.7% |
| Memory size | 101.2 MiB |
| right | |
|---|---|
| left | |
| both | 38233 |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.7168442 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | right |
|---|---|
| 2nd row | right |
| 3rd row | right |
| 4th row | right |
| 5th row | left |
Common Values
| Value | Count | Frequency (%) |
| right | 757776 | |
| left | 261091 | 15.4% |
| both | 38233 | 2.3% |
| (Missing) | 639134 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| right | 757776 | |
| left | 261091 | 24.7% |
| both | 38233 | 3.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 1057100 | |
| h | 796009 | |
| r | 757776 | |
| i | 757776 | |
| g | 757776 | |
| l | 261091 | 5.2% |
| e | 261091 | 5.2% |
| f | 261091 | 5.2% |
| b | 38233 | 0.8% |
| o | 38233 | 0.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4986176 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 1057100 | |
| h | 796009 | |
| r | 757776 | |
| i | 757776 | |
| g | 757776 | |
| l | 261091 | 5.2% |
| e | 261091 | 5.2% |
| f | 261091 | 5.2% |
| b | 38233 | 0.8% |
| o | 38233 | 0.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4986176 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 1057100 | |
| h | 796009 | |
| r | 757776 | |
| i | 757776 | |
| g | 757776 | |
| l | 261091 | 5.2% |
| e | 261091 | 5.2% |
| f | 261091 | 5.2% |
| b | 38233 | 0.8% |
| o | 38233 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4986176 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 1057100 | |
| h | 796009 | |
| r | 757776 | |
| i | 757776 | |
| g | 757776 | |
| l | 261091 | 5.2% |
| e | 261091 | 5.2% |
| f | 261091 | 5.2% |
| b | 38233 | 0.8% |
| o | 38233 | 0.8% |
height_in_cm
Real number (ℝ)
Missing 
| Distinct | 51 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 639134 |
| Missing (%) | 37.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 182.28081 |
| Minimum | 17 |
|---|---|
| Maximum | 207 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 17 |
|---|---|
| 5-th percentile | 171 |
| Q1 | 178 |
| median | 183 |
| Q3 | 187 |
| 95-th percentile | 193 |
| Maximum | 207 |
| Range | 190 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 6.7104383 |
|---|---|
| Coefficient of variation (CV) | 0.03681374 |
| Kurtosis | 4.6503543 |
| Mean | 182.28081 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | -0.25926769 |
| Sum | 1.9268904 × 108 |
| Variance | 45.029982 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 180 | 74830 | 4.4% |
| 185 | 71475 | 4.2% |
| 178 | 61950 | 3.7% |
| 183 | 60991 | 3.6% |
| 187 | 56227 | 3.3% |
| 182 | 53867 | 3.2% |
| 188 | 53805 | 3.2% |
| 175 | 50293 | 3.0% |
| 184 | 50068 | 3.0% |
| 186 | 49407 | 2.9% |
| Other values (41) | 474187 | |
| (Missing) | 639134 |
| Value | Count | Frequency (%) |
| 17 | 5 | < 0.1% |
| 19 | 10 | < 0.1% |
| 159 | 114 | < 0.1% |
| 160 | 28 | < 0.1% |
| 161 | 113 | < 0.1% |
| 162 | 21 | < 0.1% |
| 163 | 1187 | |
| 164 | 520 | < 0.1% |
| 165 | 2150 | |
| 166 | 2058 |
| Value | Count | Frequency (%) |
| 207 | 36 | < 0.1% |
| 206 | 137 | < 0.1% |
| 205 | 3 | < 0.1% |
| 204 | 7 | < 0.1% |
| 203 | 89 | < 0.1% |
| 202 | 290 | < 0.1% |
| 201 | 1649 | |
| 200 | 754 | < 0.1% |
| 199 | 1382 | |
| 198 | 3062 |
Missing 
| Distinct | 90 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 639134 |
| Missing (%) | 37.7% |
| Memory size | 12.9 MiB |
| Minimum | 2000-05-31 00:00:00 |
|---|---|
| Maximum | 2034-06-30 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
current_club_domestic_competition_id
Categorical
High correlation  Missing 
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 639134 |
| Missing (%) | 37.7% |
| Memory size | 99.5 MiB |
| ES1 | |
|---|---|
| IT1 | |
| TR1 | |
| GB1 | |
| L1 | |
| Other values (9) |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 2.9627717 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SC1 |
|---|---|
| 2nd row | TR1 |
| 3rd row | GB1 |
| 4th row | DK1 |
| 5th row | TR1 |
Common Values
| Value | Count | Frequency (%) |
| ES1 | 115155 | 6.8% |
| IT1 | 113087 | 6.7% |
| TR1 | 110164 | 6.5% |
| GB1 | 107354 | 6.3% |
| L1 | 79028 | 4.7% |
| FR1 | 77763 | 4.6% |
| GR1 | 74131 | 4.4% |
| NL1 | 73550 | 4.3% |
| RU1 | 59972 | 3.5% |
| BE1 | 57996 | 3.4% |
| Other values (4) | 188900 | 11.1% |
| (Missing) | 639134 |
Length
| Value | Count | Frequency (%) |
| es1 | 115155 | |
| it1 | 113087 | |
| tr1 | 110164 | |
| gb1 | 107354 | |
| l1 | 79028 | |
| fr1 | 77763 | |
| gr1 | 74131 | 7.0% |
| nl1 | 73550 | 7.0% |
| ru1 | 59972 | 5.7% |
| be1 | 57996 | 5.5% |
| Other values (4) | 188900 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 1057100 | |
| R | 361704 | 11.5% |
| T | 223251 | 7.1% |
| G | 181485 | 5.8% |
| E | 173151 | 5.5% |
| S | 166724 | 5.3% |
| B | 165350 | 5.3% |
| L | 152578 | 4.9% |
| I | 113087 | 3.6% |
| U | 99646 | 3.2% |
| Other values (7) | 437870 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3131946 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 1057100 | |
| R | 361704 | 11.5% |
| T | 223251 | 7.1% |
| G | 181485 | 5.8% |
| E | 173151 | 5.5% |
| S | 166724 | 5.3% |
| B | 165350 | 5.3% |
| L | 152578 | 4.9% |
| I | 113087 | 3.6% |
| U | 99646 | 3.2% |
| Other values (7) | 437870 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3131946 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 1057100 | |
| R | 361704 | 11.5% |
| T | 223251 | 7.1% |
| G | 181485 | 5.8% |
| E | 173151 | 5.5% |
| S | 166724 | 5.3% |
| B | 165350 | 5.3% |
| L | 152578 | 4.9% |
| I | 113087 | 3.6% |
| U | 99646 | 3.2% |
| Other values (7) | 437870 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3131946 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 1057100 | |
| R | 361704 | 11.5% |
| T | 223251 | 7.1% |
| G | 181485 | 5.8% |
| E | 173151 | 5.5% |
| S | 166724 | 5.3% |
| B | 165350 | 5.3% |
| L | 152578 | 4.9% |
| I | 113087 | 3.6% |
| U | 99646 | 3.2% |
| Other values (7) | 437870 |
Missing 
| Distinct | 436 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 639134 |
| Missing (%) | 37.7% |
| Memory size | 115.7 MiB |
Length
| Max length | 98 |
|---|---|
| Median length | 40 |
| Mean length | 24.152065 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Saint Mirren Football Club |
|---|---|
| 2nd row | Fatih Karagümrük |
| 3rd row | Hull City |
| 4th row | Fodbold Club Nordsjælland |
| 5th row | Fenerbahçe Spor Kulübü |
| Value | Count | Frequency (%) |
| club | 350397 | 9.8% |
| football | 222762 | 6.2% |
| de | 100050 | 2.8% |
| kulübü | 66231 | 1.9% |
| s.a.d | 62772 | 1.8% |
| fc | 54474 | 1.5% |
| calcio | 53171 | 1.5% |
| fk | 40756 | 1.1% |
| fútbol | 39493 | 1.1% |
| clube | 37072 | 1.0% |
| Other values (772) | 2540371 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2510449 | 9.8% | |
| l | 1977389 | 7.7% |
| o | 1886852 | 7.4% |
| a | 1750431 | 6.9% |
| e | 1695807 | 6.6% |
| i | 1379690 | 5.4% |
| t | 1282179 | 5.0% |
| n | 1218303 | 4.8% |
| r | 1081069 | 4.2% |
| b | 1025004 | 4.0% |
| Other values (101) | 9723975 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 25531148 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2510449 | 9.8% | |
| l | 1977389 | 7.7% |
| o | 1886852 | 7.4% |
| a | 1750431 | 6.9% |
| e | 1695807 | 6.6% |
| i | 1379690 | 5.4% |
| t | 1282179 | 5.0% |
| n | 1218303 | 4.8% |
| r | 1081069 | 4.2% |
| b | 1025004 | 4.0% |
| Other values (101) | 9723975 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 25531148 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2510449 | 9.8% | |
| l | 1977389 | 7.7% |
| o | 1886852 | 7.4% |
| a | 1750431 | 6.9% |
| e | 1695807 | 6.6% |
| i | 1379690 | 5.4% |
| t | 1282179 | 5.0% |
| n | 1218303 | 4.8% |
| r | 1081069 | 4.2% |
| b | 1025004 | 4.0% |
| Other values (101) | 9723975 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 25531148 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2510449 | 9.8% | |
| l | 1977389 | 7.7% |
| o | 1886852 | 7.4% |
| a | 1750431 | 6.9% |
| e | 1695807 | 6.6% |
| i | 1379690 | 5.4% |
| t | 1282179 | 5.0% |
| n | 1218303 | 4.8% |
| r | 1081069 | 4.2% |
| b | 1025004 | 4.0% |
| Other values (101) | 9723975 |
market_value_in_eur
Real number (ℝ)
High correlation  Missing 
| Distinct | 122 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 639134 |
| Missing (%) | 37.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6121123.6 |
| Minimum | 10000 |
|---|---|
| Maximum | 2 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 10000 |
|---|---|
| 5-th percentile | 100000 |
| Q1 | 400000 |
| median | 1300000 |
| Q3 | 5000000 |
| 95-th percentile | 30000000 |
| Maximum | 2 × 108 |
| Range | 1.9999 × 108 |
| Interquartile range (IQR) | 4600000 |
Descriptive statistics
| Standard deviation | 13425977 |
|---|---|
| Coefficient of variation (CV) | 2.1933844 |
| Kurtosis | 41.533419 |
| Mean | 6121123.6 |
| Median Absolute Deviation (MAD) | 1100000 |
| Skewness | 5.2115042 |
| Sum | 6.4706398 × 1012 |
| Variance | 1.8025686 × 1014 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 300000 | 43079 | 2.5% |
| 1500000 | 42349 | 2.5% |
| 200000 | 40191 | 2.4% |
| 1000000 | 39193 | 2.3% |
| 500000 | 36400 | 2.1% |
| 2000000 | 36343 | 2.1% |
| 400000 | 35733 | 2.1% |
| 3000000 | 33834 | 2.0% |
| 100000 | 33616 | 2.0% |
| 2500000 | 32336 | 1.9% |
| Other values (112) | 684026 | |
| (Missing) | 639134 |
| Value | Count | Frequency (%) |
| 10000 | 862 | 0.1% |
| 20000 | 22 | < 0.1% |
| 25000 | 7712 | 0.5% |
| 50000 | 16702 | |
| 75000 | 10887 | 0.6% |
| 100000 | 33616 | |
| 125000 | 6030 | 0.4% |
| 150000 | 26949 | |
| 175000 | 9548 | 0.6% |
| 200000 | 40191 |
| Value | Count | Frequency (%) |
| 200000000 | 229 | < 0.1% |
| 180000000 | 210 | < 0.1% |
| 160000000 | 365 | |
| 150000000 | 242 | < 0.1% |
| 140000000 | 675 | |
| 130000000 | 436 | |
| 110000000 | 618 | |
| 100000000 | 320 | |
| 90000000 | 488 | |
| 85000000 | 425 |
highest_market_value_in_eur
Real number (ℝ)
High correlation  Missing 
| Distinct | 156 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 639134 |
| Missing (%) | 37.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14123050 |
| Minimum | 10000 |
|---|---|
| Maximum | 2 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 10000 |
|---|---|
| 5-th percentile | 500000 |
| Q1 | 1800000 |
| median | 5500000 |
| Q3 | 18000000 |
| 95-th percentile | 55000000 |
| Maximum | 2 × 108 |
| Range | 1.9999 × 108 |
| Interquartile range (IQR) | 16200000 |
Descriptive statistics
| Standard deviation | 21127385 |
|---|---|
| Coefficient of variation (CV) | 1.4959506 |
| Kurtosis | 13.286691 |
| Mean | 14123050 |
| Median Absolute Deviation (MAD) | 4600000 |
| Skewness | 3.0841609 |
| Sum | 1.4929476 × 1013 |
| Variance | 4.4636638 × 1014 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5000000 | 41241 | 2.4% |
| 10000000 | 40977 | 2.4% |
| 3000000 | 37812 | 2.2% |
| 2000000 | 37094 | 2.2% |
| 4000000 | 36100 | 2.1% |
| 1500000 | 35633 | 2.1% |
| 2500000 | 34781 | 2.1% |
| 1000000 | 32937 | 1.9% |
| 20000000 | 28661 | 1.7% |
| 15000000 | 28157 | 1.7% |
| Other values (146) | 703707 | |
| (Missing) | 639134 |
| Value | Count | Frequency (%) |
| 10000 | 4 | < 0.1% |
| 25000 | 34 | < 0.1% |
| 50000 | 300 | < 0.1% |
| 75000 | 223 | < 0.1% |
| 100000 | 1044 | |
| 125000 | 282 | < 0.1% |
| 150000 | 1325 | |
| 175000 | 405 | < 0.1% |
| 200000 | 2522 | |
| 225000 | 748 | < 0.1% |
| Value | Count | Frequency (%) |
| 200000000 | 594 | < 0.1% |
| 180000000 | 210 | < 0.1% |
| 160000000 | 538 | < 0.1% |
| 150000000 | 2849 | |
| 140000000 | 388 | < 0.1% |
| 130000000 | 698 | < 0.1% |
| 120000000 | 878 | 0.1% |
| 110000000 | 1433 | 0.1% |
| 100000000 | 5083 | |
| 90000000 | 5390 |
Interactions
Correlations
| Unnamed: 0 | assists | competition_id | current_club_domestic_competition_id | current_club_id | foot | goals | height_in_cm | highest_market_value_in_eur | last_season | market_value_in_eur | minutes_played | player_club_id | player_current_club_id | player_id | position | sub_position | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Unnamed: 0 | 1.000 | -0.011 | 0.060 | 0.046 | -0.044 | 0.031 | -0.006 | 0.027 | 0.051 | 0.476 | 0.374 | -0.111 | 0.014 | -0.057 | 0.640 | 0.012 | 0.019 |
| assists | -0.011 | 1.000 | 0.016 | 0.013 | -0.035 | 0.016 | 0.072 | -0.085 | 0.074 | 0.021 | 0.052 | 0.055 | -0.035 | -0.035 | -0.009 | 0.065 | 0.071 |
| competition_id | 0.060 | 0.016 | 1.000 | 0.722 | 0.211 | 0.063 | 0.016 | 0.069 | 0.160 | 0.075 | 0.099 | 0.088 | 0.166 | 0.193 | 0.069 | 0.030 | 0.054 |
| current_club_domestic_competition_id | 0.046 | 0.013 | 0.722 | 1.000 | 0.246 | 0.066 | 0.011 | 0.084 | 0.160 | 0.069 | 0.133 | 0.023 | 0.178 | 0.246 | 0.070 | 0.042 | 0.062 |
| current_club_id | -0.044 | -0.035 | 0.211 | 0.246 | 1.000 | 0.026 | -0.037 | -0.053 | -0.413 | -0.176 | -0.392 | -0.023 | 0.596 | 1.000 | -0.011 | 0.028 | 0.034 |
| foot | 0.031 | 0.016 | 0.063 | 0.066 | 0.026 | 1.000 | 0.012 | 0.037 | 0.042 | 0.049 | 0.038 | 0.024 | 0.022 | 0.026 | 0.045 | 0.116 | 0.367 |
| goals | -0.006 | 0.072 | 0.016 | 0.011 | -0.037 | 0.012 | 1.000 | -0.026 | 0.094 | 0.019 | 0.068 | 0.050 | -0.031 | -0.036 | -0.006 | 0.126 | 0.099 |
| height_in_cm | 0.027 | -0.085 | 0.069 | 0.084 | -0.053 | 0.037 | -0.026 | 1.000 | 0.029 | 0.063 | 0.038 | 0.182 | -0.048 | -0.053 | -0.030 | 0.218 | 0.290 |
| highest_market_value_in_eur | 0.051 | 0.074 | 0.160 | 0.160 | -0.413 | 0.042 | 0.094 | 0.029 | 1.000 | 0.397 | 0.752 | 0.062 | -0.405 | -0.413 | -0.032 | 0.078 | 0.075 |
| last_season | 0.476 | 0.021 | 0.075 | 0.069 | -0.176 | 0.049 | 0.019 | 0.063 | 0.397 | 1.000 | 0.567 | 0.029 | -0.126 | -0.176 | 0.365 | 0.044 | 0.043 |
| market_value_in_eur | 0.374 | 0.052 | 0.099 | 0.133 | -0.392 | 0.038 | 0.068 | 0.038 | 0.752 | 0.567 | 1.000 | 0.007 | -0.300 | -0.392 | 0.443 | 0.060 | 0.052 |
| minutes_played | -0.111 | 0.055 | 0.088 | 0.023 | -0.023 | 0.024 | 0.050 | 0.182 | 0.062 | 0.029 | 0.007 | 1.000 | -0.003 | -0.024 | -0.162 | 0.244 | 0.147 |
| player_club_id | 0.014 | -0.035 | 0.166 | 0.178 | 0.596 | 0.022 | -0.031 | -0.048 | -0.405 | -0.126 | -0.300 | -0.003 | 1.000 | 0.618 | 0.080 | 0.012 | 0.020 |
| player_current_club_id | -0.057 | -0.035 | 0.193 | 0.246 | 1.000 | 0.026 | -0.036 | -0.053 | -0.413 | -0.176 | -0.392 | -0.024 | 0.618 | 1.000 | 0.001 | 0.028 | 0.035 |
| player_id | 0.640 | -0.009 | 0.069 | 0.070 | -0.011 | 0.045 | -0.006 | -0.030 | -0.032 | 0.365 | 0.443 | -0.162 | 0.080 | 0.001 | 1.000 | 0.080 | 0.062 |
| position | 0.012 | 0.065 | 0.030 | 0.042 | 0.028 | 0.116 | 0.126 | 0.218 | 0.078 | 0.044 | 0.060 | 0.244 | 0.012 | 0.028 | 0.080 | 1.000 | 1.000 |
| sub_position | 0.019 | 0.071 | 0.054 | 0.062 | 0.034 | 0.367 | 0.099 | 0.290 | 0.075 | 0.043 | 0.052 | 0.147 | 0.020 | 0.035 | 0.062 | 1.000 | 1.000 |
Missing values
Sample
| Unnamed: 0 | player_id | player_club_id | player_current_club_id | date | player_name | competition_id | goals | assists | minutes_played | first_name | last_name | name | last_season | current_club_id | country_of_citizenship | date_of_birth | sub_position | position | foot | height_in_cm | contract_expiration_date | current_club_domestic_competition_id | current_club_name | market_value_in_eur | highest_market_value_in_eur | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 38004 | 853 | 235 | 2012-07-03 | Aurélien Joachim | CLQ | 2 | 0 | 90 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1 | 1 | 79232 | 8841 | 2698 | 2012-07-05 | Ruslan Abyshov | ELQ | 0 | 0 | 90 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2 | 2 | 42792 | 6251 | 465 | 2012-07-05 | Sander Puri | ELQ | 0 | 0 | 45 | Sander | Puri | Sander Puri | 2012.0 | 465.0 | Estonia | 1988-05-07 00:00:00 | Central Midfield | Midfield | right | 177.0 | 2023-12-31 00:00:00 | SC1 | Saint Mirren Football Club | 100000.0 | 600000.0 |
| 3 | 3 | 73333 | 1274 | 6646 | 2012-07-05 | Vegar Hedenstad | ELQ | 0 | 0 | 90 | Vegar | Hedenstad | Vegar Hedenstad | 2021.0 | 6646.0 | Norway | 1991-06-26 00:00:00 | Right-Back | Defender | right | 178.0 | 2024-12-31 00:00:00 | TR1 | Fatih Karagümrük | 350000.0 | 1500000.0 |
| 4 | 4 | 122011 | 195 | 3008 | 2012-07-05 | Markus Henriksen | ELQ | 0 | 1 | 90 | Markus | Henriksen | Markus Henriksen | 2016.0 | 3008.0 | Norway | 1992-07-25 00:00:00 | Centre-Back | Defender | right | 187.0 | 2024-12-31 00:00:00 | GB1 | Hull City | 800000.0 | 5000000.0 |
| 5 | 5 | 146889 | 195 | 2778 | 2012-07-05 | Peter Ankersen | ELQ | 0 | 0 | 90 | Peter | Ankersen | Peter Ankersen | 2024.0 | 2778.0 | Denmark | 1990-09-22 00:00:00 | Right-Back | Defender | right | 180.0 | 2026-06-30 00:00:00 | DK1 | Fodbold Club Nordsjælland | 250000.0 | 3000000.0 |
| 6 | 6 | 28716 | 282 | 7185 | 2012-07-05 | Adi Adilovic | ELQ | 0 | 0 | 90 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 7 | 7 | 69445 | 282 | 19771 | 2012-07-05 | Ivan Sesar | ELQ | 0 | 1 | 90 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 8 | 8 | 19409 | 317 | 200 | 2012-07-05 | Willem Janssen | ELQ | 0 | 0 | 45 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 9 | 9 | 30003 | 317 | 317 | 2012-07-05 | Wout Brama | ELQ | 0 | 0 | 90 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| Unnamed: 0 | player_id | player_club_id | player_current_club_id | date | player_name | competition_id | goals | assists | minutes_played | first_name | last_name | name | last_season | current_club_id | country_of_citizenship | date_of_birth | sub_position | position | foot | height_in_cm | contract_expiration_date | current_club_domestic_competition_id | current_club_name | market_value_in_eur | highest_market_value_in_eur | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1696224 | 1696224 | 342151 | 2578 | 2578 | 2025-03-10 | Daniels Balodis | SFA | 0 | 0 | 90 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1696225 | 1696225 | 359199 | 2578 | 2578 | 2025-03-10 | Andy Fisher | SFA | 0 | 0 | 90 | Andy | Fisher | Andy Fisher | 2024.0 | 2578.0 | England | 1998-02-12 00:00:00 | Goalkeeper | Goalkeeper | right | 189.0 | 2025-05-31 00:00:00 | SC1 | Saint Johnstone Football Club | 900000.0 | 1000000.0 |
| 1696226 | 1696226 | 430976 | 2578 | 2578 | 2025-03-10 | Jonathan Svedberg | SFA | 0 | 0 | 69 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1696227 | 1696227 | 503731 | 2578 | 2578 | 2025-03-10 | Stephen Duke-McKenna | SFA | 0 | 0 | 45 | Stephen | Duke-McKenna | Stephen Duke-McKenna | 2024.0 | 2578.0 | Guyana | 2000-08-17 00:00:00 | Right Midfield | Midfield | right | 170.0 | 2025-05-31 00:00:00 | SC1 | Saint Johnstone Football Club | 150000.0 | 150000.0 |
| 1696228 | 1696228 | 700144 | 2578 | 2578 | 2025-03-10 | Makenzie Kirk | SFA | 0 | 0 | 90 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1696229 | 1696229 | 741267 | 2578 | 2578 | 2025-03-10 | Sam Curtis | SFA | 0 | 0 | 90 | Sam | Curtis | Sam Curtis | 2024.0 | 2578.0 | Ireland | 2005-12-01 00:00:00 | Right-Back | Defender | right | 185.0 | 2025-05-31 00:00:00 | SC1 | Saint Johnstone Football Club | 175000.0 | 175000.0 |
| 1696230 | 1696230 | 796307 | 2578 | 2578 | 2025-03-10 | Zach Mitchell | SFA | 0 | 0 | 90 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1696231 | 1696231 | 80339 | 2578 | 2578 | 2025-03-10 | Graham Carey | SFA | 1 | 0 | 21 | Graham | Carey | Graham Carey | 2024.0 | 2578.0 | Ireland | 1989-05-20 00:00:00 | Left Midfield | Midfield | left | 183.0 | 2025-05-31 00:00:00 | SC1 | Saint Johnstone Football Club | 150000.0 | 700000.0 |
| 1696232 | 1696232 | 909254 | 1241 | 43 | 2025-03-10 | Macaulay Tait | SFA | 0 | 0 | 90 | Macaulay | Tait | Macaulay Tait | 2024.0 | 43.0 | Scotland | 2005-08-27 00:00:00 | Central Midfield | Midfield | left | 170.0 | 2028-05-31 00:00:00 | SC1 | Heart of Midlothian Football Club | 200000.0 | 200000.0 |
| 1696233 | 1696233 | 91854 | 2578 | 2578 | 2025-03-10 | Barry Douglas | SFA | 0 | 0 | 90 | Barry | Douglas | Barry Douglas | 2024.0 | 2578.0 | Scotland | 1989-09-04 00:00:00 | Left-Back | Defender | left | 176.0 | 2025-05-31 00:00:00 | SC1 | Saint Johnstone Football Club | 100000.0 | 3500000.0 |